<include file='Index/header'/>

<include file='Index/left'/>


<div class="content">
    <div class="header">
        <h1 class="page-title">林州市红旗渠干部学院教学管理系统</h1>
    </div>

    <ul class="breadcrumb">
        <li><a href="Index.html">首页</a> <span class="divider">/Sql</span></li>
        <li class="active"></li>
    </ul>

    <div style="margin-left:50px;">
        <form id="form1" name="form1" method="post" action="{:U('Sql/Sql')}" >
            <table width="500" border="1" style="text-align:center">
                <tr>
                    <td>SQL查询</td>
                </tr>

                <tr>
                    <td><label for="sql"></label>
                        <textarea name="sql" id="sql" cols="400" rows="5" style="width:400px">{$sql}</textarea></td>
                </tr>

                <tr>
                    <td><input type="submit" name="tj" id="tj" value="提交"/></td>
                </tr>
            </table>
        </form>
        <!--<form id="student" name="cx" method="post" action="{:U('Sql/Studentlist')}" style="margin-left: 60%">-->
            <!--<input type="text" name="student_name" style="width:120px">-->
            <!--<button type="button" onclick="submit()">&nbsp;&nbsp;按姓名查学员-->
            <!--</button>-->
        <!--</form>-->

        <!--<form id="cx" name="cx" method="post" action="{:U('Sql/Schedulelist')}" style="margin-left: 60%">-->
            <!--<input type="text" name="schedule_name" style="width:120px">-->
            <!--<button type="button" onclick="submit()">&nbsp;&nbsp;按名称查班次-->
            <!--</button>-->
        <!--</form>-->

        <!--<form id="cn" name="cn" method="post" action="{:U('Sql/Studentlist2')}" style="margin-left: 60%">-->
            <!--<input type="text" name="class_num" style="width:120px">-->
            <!--<button type="button" onclick="submit()">&nbsp;&nbsp;按班次编号查询学员-->
            <!--</button>-->
        <!--</form>-->
    </div>
    <hr/>
    <if condition="$list neq ''">
        <div style="margin-left:50px;">
            <table width="200" border="1">
                <volist name='list' id='vo' offset='0' length='1'>
                    <tr>
                        <volist name="vo" id="vp">
                            <td>{$key}</td>
                        </volist>
                    </tr>
                </volist>

                <volist name='list' id='vo'>
                    <tr>
                        <volist name="vo" id="vp">
                            <td>{$vp}</td>
                        </volist>
                    </tr>
                </volist>
            </table>
        </div>
        <br/>
        <div style="margin-left:300px;">
            <button class="btn" onclick="window.location='__CONTROLLER__/out'">导出</button>
        </div>
    </if>
    <include file='Index/footer'/>
 